J. Craig Williams — Smartsheet Community

Skip to content

Overview

Overview
Email	jcwill23@gmail.com
Roles	Member
Badges	35

About Me

About Me
Area of Expertise
About Me	Smartsheet Certified User <br /><br />See:<br />https://ronin-global.com/contact-us-smartsheet-help/<br />to see info about me or how to contact me.<br />The password is "thankyou"<br /><br />Also I have posted tips and tricks for Smartsheet here:<br />https://ronin-global.com/category/smartsheet-help/
How I Use Smartsheet	Daily tasks, any around the house or longer than a few days projects, project management, resource management.
Linkedin	http://www.linkedin.com/in/jcwill23
Twitter Page

Analytics

4,105

Posts

53

Visits

23.8k

Points

Nov 21, 2015

Join Date

Feb 21, 2025

Last Active

Re: How can I convert a date to plain text?

J. Craig Williams

10/09/18

Here's the trick: =(-your-date-formula) + "" =TODAY(1) + "" will be 10/10/2018 (as I type this). The + "" will convert the formula in the parenthesis () to text. Craig

4 ·
Re: Export sheet URLs to excel

J. Craig Williams

10/15/17

salley280, Yes. If you are a SysAdmin, you can download the Sheet Access Report (Admin | User Management | More Actions) This will be a csv file. You can import that back to Smarsheet OR open in anot…

1 ·
Re: Max child value dependent on max date

J. Craig Williams

08/24/18

It doesn't, but it may be because is 10pm on a Friday night. Are you looking for the Max of the date (Dec 30, 2015) -- ie the most recent date and then the max level recorded on that date? If so, the…

1 ·
Re: MS Project & Smartsheets - working together longterm

J. Craig Williams

03/21/16

Tim's comments spark another (recent) experience. As Tim said "I've also found a project plan will be seutp and then not viewed the rest of the project." Smartsheet can allow the task owner…

1 ·
Re: Adding time durations as actual numbers

J. Craig Williams

08/16/18

Here's a shorter version: =INT(Sec@row / 3600) + ":" + IF(INT((Sec@row - INT(Sec@row / 3600) * 3600)) < 600, "0") + INT((Sec@row - INT(Sec@row / 3600) * 3600) / 60) + ":&q…

1 ·